﻿CREATE TABLE [dbo].[ActionReason] (

	[Id] [dbo].[Id] NOT NULL  IDENTITY(1000000000, 1), 
	
    [Name] [dbo].[Name] NOT NULL, 
       	
    [Description] [dbo].[Description] NOT NULL, 
	
    [EntityType] [dbo].[EnumerationValue] NOT NULL DEFAULT 0, 

    [ActionType] [dbo].[EnumerationValue] NOT NULL DEFAULT 0, 

	[Enabled] [dbo].[Enabled] NOT NULL DEFAULT 1,

    [CreateId] [dbo].[Name] NOT NULL DEFAULT SUSER_NAME () , 

    [CreateDateTime] [dbo].[CreateModifiedDateTime] NOT NULL DEFAULT GETDATE() , 

    [ModifiedId] [dbo].[Name] NOT NULL DEFAULT SUSER_NAME (),

    [ModifiedDateTime] [dbo].[CreateModifiedDateTime] NOT NULL DEFAULT GETDATE(), 
 
    CONSTRAINT [PK_ActionReason] PRIMARY KEY ([Id]), 

	CONSTRAINT [UNQ_ActionReason_Name] UNIQUE (Name)    

)
